/*
*
* SysUserExample.java
* Copyright(C) 2017-2020 fendo公司
* @date 2018-12-04
*/
package com.mass.core.sys.user.model;

import java.util.ArrayList;
import java.util.List;

public class SysUserExample {
    /**
     * t_sys_user
     */
    protected String orderByClause;

    /**
     * t_sys_user
     */
    protected boolean distinct;

    /**
     * t_sys_user
     */
    protected List<Criteria> oredCriteria;

    /**
     * t_sys_user
     */
    protected Integer pageIndex;

    /**
     * t_sys_user
     */
    protected Integer pageSize;

    /**
     *
     * @mbg.generated
     */
    public SysUserExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     *
     * @mbg.generated
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     *
     * @mbg.generated
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     *
     * @mbg.generated
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     *
     * @mbg.generated
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     *
     * @mbg.generated
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     *
     * @mbg.generated
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     *
     * @mbg.generated
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     *
     * @mbg.generated
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     *
     * @mbg.generated
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     *
     * @mbg.generated
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     *
     * @mbg.generated
     */
    public void setPageIndex(Integer pageIndex) {
        this.pageIndex=pageIndex;
    }

    /**
     *
     * @mbg.generated
     */
    public Integer getPageIndex() {
        return pageIndex;
    }

    /**
     *
     * @mbg.generated
     */
    public void setPageSize(Integer pageSize) {
        this.pageSize=pageSize;
    }

    /**
     *
     * @mbg.generated
     */
    public Integer getPageSize() {
        return pageSize;
    }

    /**
     * t_sys_user null
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andAccountIsNull() {
            addCriterion("ACCOUNT is null");
            return (Criteria) this;
        }

        public Criteria andAccountIsNotNull() {
            addCriterion("ACCOUNT is not null");
            return (Criteria) this;
        }

        public Criteria andAccountEqualTo(String value) {
            addCriterion("ACCOUNT =", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountNotEqualTo(String value) {
            addCriterion("ACCOUNT <>", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountGreaterThan(String value) {
            addCriterion("ACCOUNT >", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountGreaterThanOrEqualTo(String value) {
            addCriterion("ACCOUNT >=", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountLessThan(String value) {
            addCriterion("ACCOUNT <", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountLessThanOrEqualTo(String value) {
            addCriterion("ACCOUNT <=", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountLike(String value) {
            addCriterion("ACCOUNT like", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountNotLike(String value) {
            addCriterion("ACCOUNT not like", value, "account");
            return (Criteria) this;
        }

        public Criteria andAccountIn(List<String> values) {
            addCriterion("ACCOUNT in", values, "account");
            return (Criteria) this;
        }

        public Criteria andAccountNotIn(List<String> values) {
            addCriterion("ACCOUNT not in", values, "account");
            return (Criteria) this;
        }

        public Criteria andAccountBetween(String value1, String value2) {
            addCriterion("ACCOUNT between", value1, value2, "account");
            return (Criteria) this;
        }

        public Criteria andAccountNotBetween(String value1, String value2) {
            addCriterion("ACCOUNT not between", value1, value2, "account");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("NAME is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("NAME is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("NAME =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("NAME <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("NAME >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("NAME >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("NAME <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("NAME <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("NAME like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("NAME not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("NAME in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("NAME not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("NAME between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("NAME not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNull() {
            addCriterion("PASSWORD is null");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNotNull() {
            addCriterion("PASSWORD is not null");
            return (Criteria) this;
        }

        public Criteria andPasswordEqualTo(String value) {
            addCriterion("PASSWORD =", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotEqualTo(String value) {
            addCriterion("PASSWORD <>", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThan(String value) {
            addCriterion("PASSWORD >", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("PASSWORD >=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThan(String value) {
            addCriterion("PASSWORD <", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThanOrEqualTo(String value) {
            addCriterion("PASSWORD <=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLike(String value) {
            addCriterion("PASSWORD like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotLike(String value) {
            addCriterion("PASSWORD not like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordIn(List<String> values) {
            addCriterion("PASSWORD in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotIn(List<String> values) {
            addCriterion("PASSWORD not in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordBetween(String value1, String value2) {
            addCriterion("PASSWORD between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotBetween(String value1, String value2) {
            addCriterion("PASSWORD not between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andEnabledIsNull() {
            addCriterion("ENABLED is null");
            return (Criteria) this;
        }

        public Criteria andEnabledIsNotNull() {
            addCriterion("ENABLED is not null");
            return (Criteria) this;
        }

        public Criteria andEnabledEqualTo(Integer value) {
            addCriterion("ENABLED =", value, "enabled");
            return (Criteria) this;
        }

        public Criteria andEnabledNotEqualTo(Integer value) {
            addCriterion("ENABLED <>", value, "enabled");
            return (Criteria) this;
        }

        public Criteria andEnabledGreaterThan(Integer value) {
            addCriterion("ENABLED >", value, "enabled");
            return (Criteria) this;
        }

        public Criteria andEnabledGreaterThanOrEqualTo(Integer value) {
            addCriterion("ENABLED >=", value, "enabled");
            return (Criteria) this;
        }

        public Criteria andEnabledLessThan(Integer value) {
            addCriterion("ENABLED <", value, "enabled");
            return (Criteria) this;
        }

        public Criteria andEnabledLessThanOrEqualTo(Integer value) {
            addCriterion("ENABLED <=", value, "enabled");
            return (Criteria) this;
        }

        public Criteria andEnabledIn(List<Integer> values) {
            addCriterion("ENABLED in", values, "enabled");
            return (Criteria) this;
        }

        public Criteria andEnabledNotIn(List<Integer> values) {
            addCriterion("ENABLED not in", values, "enabled");
            return (Criteria) this;
        }

        public Criteria andEnabledBetween(Integer value1, Integer value2) {
            addCriterion("ENABLED between", value1, value2, "enabled");
            return (Criteria) this;
        }

        public Criteria andEnabledNotBetween(Integer value1, Integer value2) {
            addCriterion("ENABLED not between", value1, value2, "enabled");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpIsNull() {
            addCriterion("LAST_LOGIN_IP is null");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpIsNotNull() {
            addCriterion("LAST_LOGIN_IP is not null");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpEqualTo(String value) {
            addCriterion("LAST_LOGIN_IP =", value, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpNotEqualTo(String value) {
            addCriterion("LAST_LOGIN_IP <>", value, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpGreaterThan(String value) {
            addCriterion("LAST_LOGIN_IP >", value, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpGreaterThanOrEqualTo(String value) {
            addCriterion("LAST_LOGIN_IP >=", value, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpLessThan(String value) {
            addCriterion("LAST_LOGIN_IP <", value, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpLessThanOrEqualTo(String value) {
            addCriterion("LAST_LOGIN_IP <=", value, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpLike(String value) {
            addCriterion("LAST_LOGIN_IP like", value, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpNotLike(String value) {
            addCriterion("LAST_LOGIN_IP not like", value, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpIn(List<String> values) {
            addCriterion("LAST_LOGIN_IP in", values, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpNotIn(List<String> values) {
            addCriterion("LAST_LOGIN_IP not in", values, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpBetween(String value1, String value2) {
            addCriterion("LAST_LOGIN_IP between", value1, value2, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginIpNotBetween(String value1, String value2) {
            addCriterion("LAST_LOGIN_IP not between", value1, value2, "lastLoginIp");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeIsNull() {
            addCriterion("LAST_LOGIN_TIME is null");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeIsNotNull() {
            addCriterion("LAST_LOGIN_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeEqualTo(String value) {
            addCriterion("LAST_LOGIN_TIME =", value, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeNotEqualTo(String value) {
            addCriterion("LAST_LOGIN_TIME <>", value, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeGreaterThan(String value) {
            addCriterion("LAST_LOGIN_TIME >", value, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeGreaterThanOrEqualTo(String value) {
            addCriterion("LAST_LOGIN_TIME >=", value, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeLessThan(String value) {
            addCriterion("LAST_LOGIN_TIME <", value, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeLessThanOrEqualTo(String value) {
            addCriterion("LAST_LOGIN_TIME <=", value, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeLike(String value) {
            addCriterion("LAST_LOGIN_TIME like", value, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeNotLike(String value) {
            addCriterion("LAST_LOGIN_TIME not like", value, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeIn(List<String> values) {
            addCriterion("LAST_LOGIN_TIME in", values, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeNotIn(List<String> values) {
            addCriterion("LAST_LOGIN_TIME not in", values, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeBetween(String value1, String value2) {
            addCriterion("LAST_LOGIN_TIME between", value1, value2, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andLastLoginTimeNotBetween(String value1, String value2) {
            addCriterion("LAST_LOGIN_TIME not between", value1, value2, "lastLoginTime");
            return (Criteria) this;
        }

        public Criteria andAPersonalBaseIdIsNull() {
            addCriterion("A_PERSONAL_BASE_ID is null");
            return (Criteria) this;
        }

        public Criteria andAPersonalBaseIdIsNotNull() {
            addCriterion("A_PERSONAL_BASE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andAPersonalBaseIdEqualTo(Long value) {
            addCriterion("A_PERSONAL_BASE_ID =", value, "aPersonalBaseId");
            return (Criteria) this;
        }

        public Criteria andAPersonalBaseIdNotEqualTo(Long value) {
            addCriterion("A_PERSONAL_BASE_ID <>", value, "aPersonalBaseId");
            return (Criteria) this;
        }

        public Criteria andAPersonalBaseIdGreaterThan(Long value) {
            addCriterion("A_PERSONAL_BASE_ID >", value, "aPersonalBaseId");
            return (Criteria) this;
        }

        public Criteria andAPersonalBaseIdGreaterThanOrEqualTo(Long value) {
            addCriterion("A_PERSONAL_BASE_ID >=", value, "aPersonalBaseId");
            return (Criteria) this;
        }

        public Criteria andAPersonalBaseIdLessThan(Long value) {
            addCriterion("A_PERSONAL_BASE_ID <", value, "aPersonalBaseId");
            return (Criteria) this;
        }

        public Criteria andAPersonalBaseIdLessThanOrEqualTo(Long value) {
            addCriterion("A_PERSONAL_BASE_ID <=", value, "aPersonalBaseId");
            return (Criteria) this;
        }

        public Criteria andAPersonalBaseIdIn(List<Long> values) {
            addCriterion("A_PERSONAL_BASE_ID in", values, "aPersonalBaseId");
            return (Criteria) this;
        }

        public Criteria andAPersonalBaseIdNotIn(List<Long> values) {
            addCriterion("A_PERSONAL_BASE_ID not in", values, "aPersonalBaseId");
            return (Criteria) this;
        }

        public Criteria andAPersonalBaseIdBetween(Long value1, Long value2) {
            addCriterion("A_PERSONAL_BASE_ID between", value1, value2, "aPersonalBaseId");
            return (Criteria) this;
        }

        public Criteria andAPersonalBaseIdNotBetween(Long value1, Long value2) {
            addCriterion("A_PERSONAL_BASE_ID not between", value1, value2, "aPersonalBaseId");
            return (Criteria) this;
        }

        public Criteria andEmployeeHeadIsNull() {
            addCriterion("EMPLOYEE_HEAD is null");
            return (Criteria) this;
        }

        public Criteria andEmployeeHeadIsNotNull() {
            addCriterion("EMPLOYEE_HEAD is not null");
            return (Criteria) this;
        }

        public Criteria andEmployeeHeadEqualTo(String value) {
            addCriterion("EMPLOYEE_HEAD =", value, "employeeHead");
            return (Criteria) this;
        }

        public Criteria andEmployeeHeadNotEqualTo(String value) {
            addCriterion("EMPLOYEE_HEAD <>", value, "employeeHead");
            return (Criteria) this;
        }

        public Criteria andEmployeeHeadGreaterThan(String value) {
            addCriterion("EMPLOYEE_HEAD >", value, "employeeHead");
            return (Criteria) this;
        }

        public Criteria andEmployeeHeadGreaterThanOrEqualTo(String value) {
            addCriterion("EMPLOYEE_HEAD >=", value, "employeeHead");
            return (Criteria) this;
        }

        public Criteria andEmployeeHeadLessThan(String value) {
            addCriterion("EMPLOYEE_HEAD <", value, "employeeHead");
            return (Criteria) this;
        }

        public Criteria andEmployeeHeadLessThanOrEqualTo(String value) {
            addCriterion("EMPLOYEE_HEAD <=", value, "employeeHead");
            return (Criteria) this;
        }

        public Criteria andEmployeeHeadLike(String value) {
            addCriterion("EMPLOYEE_HEAD like", value, "employeeHead");
            return (Criteria) this;
        }

        public Criteria andEmployeeHeadNotLike(String value) {
            addCriterion("EMPLOYEE_HEAD not like", value, "employeeHead");
            return (Criteria) this;
        }

        public Criteria andEmployeeHeadIn(List<String> values) {
            addCriterion("EMPLOYEE_HEAD in", values, "employeeHead");
            return (Criteria) this;
        }

        public Criteria andEmployeeHeadNotIn(List<String> values) {
            addCriterion("EMPLOYEE_HEAD not in", values, "employeeHead");
            return (Criteria) this;
        }

        public Criteria andEmployeeHeadBetween(String value1, String value2) {
            addCriterion("EMPLOYEE_HEAD between", value1, value2, "employeeHead");
            return (Criteria) this;
        }

        public Criteria andEmployeeHeadNotBetween(String value1, String value2) {
            addCriterion("EMPLOYEE_HEAD not between", value1, value2, "employeeHead");
            return (Criteria) this;
        }

        public Criteria andDescriptionIsNull() {
            addCriterion("DESCRIPTION is null");
            return (Criteria) this;
        }

        public Criteria andDescriptionIsNotNull() {
            addCriterion("DESCRIPTION is not null");
            return (Criteria) this;
        }

        public Criteria andDescriptionEqualTo(String value) {
            addCriterion("DESCRIPTION =", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotEqualTo(String value) {
            addCriterion("DESCRIPTION <>", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionGreaterThan(String value) {
            addCriterion("DESCRIPTION >", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionGreaterThanOrEqualTo(String value) {
            addCriterion("DESCRIPTION >=", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLessThan(String value) {
            addCriterion("DESCRIPTION <", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLessThanOrEqualTo(String value) {
            addCriterion("DESCRIPTION <=", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLike(String value) {
            addCriterion("DESCRIPTION like", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotLike(String value) {
            addCriterion("DESCRIPTION not like", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionIn(List<String> values) {
            addCriterion("DESCRIPTION in", values, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotIn(List<String> values) {
            addCriterion("DESCRIPTION not in", values, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionBetween(String value1, String value2) {
            addCriterion("DESCRIPTION between", value1, value2, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotBetween(String value1, String value2) {
            addCriterion("DESCRIPTION not between", value1, value2, "description");
            return (Criteria) this;
        }

        public Criteria andRoleIdIsNull() {
            addCriterion("ROLE_ID is null");
            return (Criteria) this;
        }

        public Criteria andRoleIdIsNotNull() {
            addCriterion("ROLE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andRoleIdEqualTo(Long value) {
            addCriterion("ROLE_ID =", value, "roleId");
            return (Criteria) this;
        }

        public Criteria andRoleIdNotEqualTo(Long value) {
            addCriterion("ROLE_ID <>", value, "roleId");
            return (Criteria) this;
        }

        public Criteria andRoleIdGreaterThan(Long value) {
            addCriterion("ROLE_ID >", value, "roleId");
            return (Criteria) this;
        }

        public Criteria andRoleIdGreaterThanOrEqualTo(Long value) {
            addCriterion("ROLE_ID >=", value, "roleId");
            return (Criteria) this;
        }

        public Criteria andRoleIdLessThan(Long value) {
            addCriterion("ROLE_ID <", value, "roleId");
            return (Criteria) this;
        }

        public Criteria andRoleIdLessThanOrEqualTo(Long value) {
            addCriterion("ROLE_ID <=", value, "roleId");
            return (Criteria) this;
        }

        public Criteria andRoleIdIn(List<Long> values) {
            addCriterion("ROLE_ID in", values, "roleId");
            return (Criteria) this;
        }

        public Criteria andRoleIdNotIn(List<Long> values) {
            addCriterion("ROLE_ID not in", values, "roleId");
            return (Criteria) this;
        }

        public Criteria andRoleIdBetween(Long value1, Long value2) {
            addCriterion("ROLE_ID between", value1, value2, "roleId");
            return (Criteria) this;
        }

        public Criteria andRoleIdNotBetween(Long value1, Long value2) {
            addCriterion("ROLE_ID not between", value1, value2, "roleId");
            return (Criteria) this;
        }

        public Criteria andOpenIdIsNull() {
            addCriterion("OPEN_ID is null");
            return (Criteria) this;
        }

        public Criteria andOpenIdIsNotNull() {
            addCriterion("OPEN_ID is not null");
            return (Criteria) this;
        }

        public Criteria andOpenIdEqualTo(String value) {
            addCriterion("OPEN_ID =", value, "openId");
            return (Criteria) this;
        }

        public Criteria andOpenIdNotEqualTo(String value) {
            addCriterion("OPEN_ID <>", value, "openId");
            return (Criteria) this;
        }

        public Criteria andOpenIdGreaterThan(String value) {
            addCriterion("OPEN_ID >", value, "openId");
            return (Criteria) this;
        }

        public Criteria andOpenIdGreaterThanOrEqualTo(String value) {
            addCriterion("OPEN_ID >=", value, "openId");
            return (Criteria) this;
        }

        public Criteria andOpenIdLessThan(String value) {
            addCriterion("OPEN_ID <", value, "openId");
            return (Criteria) this;
        }

        public Criteria andOpenIdLessThanOrEqualTo(String value) {
            addCriterion("OPEN_ID <=", value, "openId");
            return (Criteria) this;
        }

        public Criteria andOpenIdLike(String value) {
            addCriterion("OPEN_ID like", value, "openId");
            return (Criteria) this;
        }

        public Criteria andOpenIdNotLike(String value) {
            addCriterion("OPEN_ID not like", value, "openId");
            return (Criteria) this;
        }

        public Criteria andOpenIdIn(List<String> values) {
            addCriterion("OPEN_ID in", values, "openId");
            return (Criteria) this;
        }

        public Criteria andOpenIdNotIn(List<String> values) {
            addCriterion("OPEN_ID not in", values, "openId");
            return (Criteria) this;
        }

        public Criteria andOpenIdBetween(String value1, String value2) {
            addCriterion("OPEN_ID between", value1, value2, "openId");
            return (Criteria) this;
        }

        public Criteria andOpenIdNotBetween(String value1, String value2) {
            addCriterion("OPEN_ID not between", value1, value2, "openId");
            return (Criteria) this;
        }

        public Criteria andTabCacheIsNull() {
            addCriterion("TAB_CACHE is null");
            return (Criteria) this;
        }

        public Criteria andTabCacheIsNotNull() {
            addCriterion("TAB_CACHE is not null");
            return (Criteria) this;
        }

        public Criteria andTabCacheEqualTo(Integer value) {
            addCriterion("TAB_CACHE =", value, "tabCache");
            return (Criteria) this;
        }

        public Criteria andTabCacheNotEqualTo(Integer value) {
            addCriterion("TAB_CACHE <>", value, "tabCache");
            return (Criteria) this;
        }

        public Criteria andTabCacheGreaterThan(Integer value) {
            addCriterion("TAB_CACHE >", value, "tabCache");
            return (Criteria) this;
        }

        public Criteria andTabCacheGreaterThanOrEqualTo(Integer value) {
            addCriterion("TAB_CACHE >=", value, "tabCache");
            return (Criteria) this;
        }

        public Criteria andTabCacheLessThan(Integer value) {
            addCriterion("TAB_CACHE <", value, "tabCache");
            return (Criteria) this;
        }

        public Criteria andTabCacheLessThanOrEqualTo(Integer value) {
            addCriterion("TAB_CACHE <=", value, "tabCache");
            return (Criteria) this;
        }

        public Criteria andTabCacheIn(List<Integer> values) {
            addCriterion("TAB_CACHE in", values, "tabCache");
            return (Criteria) this;
        }

        public Criteria andTabCacheNotIn(List<Integer> values) {
            addCriterion("TAB_CACHE not in", values, "tabCache");
            return (Criteria) this;
        }

        public Criteria andTabCacheBetween(Integer value1, Integer value2) {
            addCriterion("TAB_CACHE between", value1, value2, "tabCache");
            return (Criteria) this;
        }

        public Criteria andTabCacheNotBetween(Integer value1, Integer value2) {
            addCriterion("TAB_CACHE not between", value1, value2, "tabCache");
            return (Criteria) this;
        }

        public Criteria andTabRefreshIsNull() {
            addCriterion("TAB_REFRESH is null");
            return (Criteria) this;
        }

        public Criteria andTabRefreshIsNotNull() {
            addCriterion("TAB_REFRESH is not null");
            return (Criteria) this;
        }

        public Criteria andTabRefreshEqualTo(Integer value) {
            addCriterion("TAB_REFRESH =", value, "tabRefresh");
            return (Criteria) this;
        }

        public Criteria andTabRefreshNotEqualTo(Integer value) {
            addCriterion("TAB_REFRESH <>", value, "tabRefresh");
            return (Criteria) this;
        }

        public Criteria andTabRefreshGreaterThan(Integer value) {
            addCriterion("TAB_REFRESH >", value, "tabRefresh");
            return (Criteria) this;
        }

        public Criteria andTabRefreshGreaterThanOrEqualTo(Integer value) {
            addCriterion("TAB_REFRESH >=", value, "tabRefresh");
            return (Criteria) this;
        }

        public Criteria andTabRefreshLessThan(Integer value) {
            addCriterion("TAB_REFRESH <", value, "tabRefresh");
            return (Criteria) this;
        }

        public Criteria andTabRefreshLessThanOrEqualTo(Integer value) {
            addCriterion("TAB_REFRESH <=", value, "tabRefresh");
            return (Criteria) this;
        }

        public Criteria andTabRefreshIn(List<Integer> values) {
            addCriterion("TAB_REFRESH in", values, "tabRefresh");
            return (Criteria) this;
        }

        public Criteria andTabRefreshNotIn(List<Integer> values) {
            addCriterion("TAB_REFRESH not in", values, "tabRefresh");
            return (Criteria) this;
        }

        public Criteria andTabRefreshBetween(Integer value1, Integer value2) {
            addCriterion("TAB_REFRESH between", value1, value2, "tabRefresh");
            return (Criteria) this;
        }

        public Criteria andTabRefreshNotBetween(Integer value1, Integer value2) {
            addCriterion("TAB_REFRESH not between", value1, value2, "tabRefresh");
            return (Criteria) this;
        }

        public Criteria andASingleLoginIsNull() {
            addCriterion("A_SINGLE_LOGIN is null");
            return (Criteria) this;
        }

        public Criteria andASingleLoginIsNotNull() {
            addCriterion("A_SINGLE_LOGIN is not null");
            return (Criteria) this;
        }

        public Criteria andASingleLoginEqualTo(Integer value) {
            addCriterion("A_SINGLE_LOGIN =", value, "aSingleLogin");
            return (Criteria) this;
        }

        public Criteria andASingleLoginNotEqualTo(Integer value) {
            addCriterion("A_SINGLE_LOGIN <>", value, "aSingleLogin");
            return (Criteria) this;
        }

        public Criteria andASingleLoginGreaterThan(Integer value) {
            addCriterion("A_SINGLE_LOGIN >", value, "aSingleLogin");
            return (Criteria) this;
        }

        public Criteria andASingleLoginGreaterThanOrEqualTo(Integer value) {
            addCriterion("A_SINGLE_LOGIN >=", value, "aSingleLogin");
            return (Criteria) this;
        }

        public Criteria andASingleLoginLessThan(Integer value) {
            addCriterion("A_SINGLE_LOGIN <", value, "aSingleLogin");
            return (Criteria) this;
        }

        public Criteria andASingleLoginLessThanOrEqualTo(Integer value) {
            addCriterion("A_SINGLE_LOGIN <=", value, "aSingleLogin");
            return (Criteria) this;
        }

        public Criteria andASingleLoginIn(List<Integer> values) {
            addCriterion("A_SINGLE_LOGIN in", values, "aSingleLogin");
            return (Criteria) this;
        }

        public Criteria andASingleLoginNotIn(List<Integer> values) {
            addCriterion("A_SINGLE_LOGIN not in", values, "aSingleLogin");
            return (Criteria) this;
        }

        public Criteria andASingleLoginBetween(Integer value1, Integer value2) {
            addCriterion("A_SINGLE_LOGIN between", value1, value2, "aSingleLogin");
            return (Criteria) this;
        }

        public Criteria andASingleLoginNotBetween(Integer value1, Integer value2) {
            addCriterion("A_SINGLE_LOGIN not between", value1, value2, "aSingleLogin");
            return (Criteria) this;
        }

        public Criteria andLockScreenIsNull() {
            addCriterion("LOCK_SCREEN is null");
            return (Criteria) this;
        }

        public Criteria andLockScreenIsNotNull() {
            addCriterion("LOCK_SCREEN is not null");
            return (Criteria) this;
        }

        public Criteria andLockScreenEqualTo(Integer value) {
            addCriterion("LOCK_SCREEN =", value, "lockScreen");
            return (Criteria) this;
        }

        public Criteria andLockScreenNotEqualTo(Integer value) {
            addCriterion("LOCK_SCREEN <>", value, "lockScreen");
            return (Criteria) this;
        }

        public Criteria andLockScreenGreaterThan(Integer value) {
            addCriterion("LOCK_SCREEN >", value, "lockScreen");
            return (Criteria) this;
        }

        public Criteria andLockScreenGreaterThanOrEqualTo(Integer value) {
            addCriterion("LOCK_SCREEN >=", value, "lockScreen");
            return (Criteria) this;
        }

        public Criteria andLockScreenLessThan(Integer value) {
            addCriterion("LOCK_SCREEN <", value, "lockScreen");
            return (Criteria) this;
        }

        public Criteria andLockScreenLessThanOrEqualTo(Integer value) {
            addCriterion("LOCK_SCREEN <=", value, "lockScreen");
            return (Criteria) this;
        }

        public Criteria andLockScreenIn(List<Integer> values) {
            addCriterion("LOCK_SCREEN in", values, "lockScreen");
            return (Criteria) this;
        }

        public Criteria andLockScreenNotIn(List<Integer> values) {
            addCriterion("LOCK_SCREEN not in", values, "lockScreen");
            return (Criteria) this;
        }

        public Criteria andLockScreenBetween(Integer value1, Integer value2) {
            addCriterion("LOCK_SCREEN between", value1, value2, "lockScreen");
            return (Criteria) this;
        }

        public Criteria andLockScreenNotBetween(Integer value1, Integer value2) {
            addCriterion("LOCK_SCREEN not between", value1, value2, "lockScreen");
            return (Criteria) this;
        }

        public Criteria andNumberPasswordErrorIsNull() {
            addCriterion("NUMBER_PASSWORD_ERROR is null");
            return (Criteria) this;
        }

        public Criteria andNumberPasswordErrorIsNotNull() {
            addCriterion("NUMBER_PASSWORD_ERROR is not null");
            return (Criteria) this;
        }

        public Criteria andNumberPasswordErrorEqualTo(Integer value) {
            addCriterion("NUMBER_PASSWORD_ERROR =", value, "numberPasswordError");
            return (Criteria) this;
        }

        public Criteria andNumberPasswordErrorNotEqualTo(Integer value) {
            addCriterion("NUMBER_PASSWORD_ERROR <>", value, "numberPasswordError");
            return (Criteria) this;
        }

        public Criteria andNumberPasswordErrorGreaterThan(Integer value) {
            addCriterion("NUMBER_PASSWORD_ERROR >", value, "numberPasswordError");
            return (Criteria) this;
        }

        public Criteria andNumberPasswordErrorGreaterThanOrEqualTo(Integer value) {
            addCriterion("NUMBER_PASSWORD_ERROR >=", value, "numberPasswordError");
            return (Criteria) this;
        }

        public Criteria andNumberPasswordErrorLessThan(Integer value) {
            addCriterion("NUMBER_PASSWORD_ERROR <", value, "numberPasswordError");
            return (Criteria) this;
        }

        public Criteria andNumberPasswordErrorLessThanOrEqualTo(Integer value) {
            addCriterion("NUMBER_PASSWORD_ERROR <=", value, "numberPasswordError");
            return (Criteria) this;
        }

        public Criteria andNumberPasswordErrorIn(List<Integer> values) {
            addCriterion("NUMBER_PASSWORD_ERROR in", values, "numberPasswordError");
            return (Criteria) this;
        }

        public Criteria andNumberPasswordErrorNotIn(List<Integer> values) {
            addCriterion("NUMBER_PASSWORD_ERROR not in", values, "numberPasswordError");
            return (Criteria) this;
        }

        public Criteria andNumberPasswordErrorBetween(Integer value1, Integer value2) {
            addCriterion("NUMBER_PASSWORD_ERROR between", value1, value2, "numberPasswordError");
            return (Criteria) this;
        }

        public Criteria andNumberPasswordErrorNotBetween(Integer value1, Integer value2) {
            addCriterion("NUMBER_PASSWORD_ERROR not between", value1, value2, "numberPasswordError");
            return (Criteria) this;
        }

        public Criteria andAnnouncementIsNull() {
            addCriterion("ANNOUNCEMENT is null");
            return (Criteria) this;
        }

        public Criteria andAnnouncementIsNotNull() {
            addCriterion("ANNOUNCEMENT is not null");
            return (Criteria) this;
        }

        public Criteria andAnnouncementEqualTo(Integer value) {
            addCriterion("ANNOUNCEMENT =", value, "announcement");
            return (Criteria) this;
        }

        public Criteria andAnnouncementNotEqualTo(Integer value) {
            addCriterion("ANNOUNCEMENT <>", value, "announcement");
            return (Criteria) this;
        }

        public Criteria andAnnouncementGreaterThan(Integer value) {
            addCriterion("ANNOUNCEMENT >", value, "announcement");
            return (Criteria) this;
        }

        public Criteria andAnnouncementGreaterThanOrEqualTo(Integer value) {
            addCriterion("ANNOUNCEMENT >=", value, "announcement");
            return (Criteria) this;
        }

        public Criteria andAnnouncementLessThan(Integer value) {
            addCriterion("ANNOUNCEMENT <", value, "announcement");
            return (Criteria) this;
        }

        public Criteria andAnnouncementLessThanOrEqualTo(Integer value) {
            addCriterion("ANNOUNCEMENT <=", value, "announcement");
            return (Criteria) this;
        }

        public Criteria andAnnouncementIn(List<Integer> values) {
            addCriterion("ANNOUNCEMENT in", values, "announcement");
            return (Criteria) this;
        }

        public Criteria andAnnouncementNotIn(List<Integer> values) {
            addCriterion("ANNOUNCEMENT not in", values, "announcement");
            return (Criteria) this;
        }

        public Criteria andAnnouncementBetween(Integer value1, Integer value2) {
            addCriterion("ANNOUNCEMENT between", value1, value2, "announcement");
            return (Criteria) this;
        }

        public Criteria andAnnouncementNotBetween(Integer value1, Integer value2) {
            addCriterion("ANNOUNCEMENT not between", value1, value2, "announcement");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("CREATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("CREATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(String value) {
            addCriterion("CREATE_TIME =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(String value) {
            addCriterion("CREATE_TIME <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(String value) {
            addCriterion("CREATE_TIME >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_TIME >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(String value) {
            addCriterion("CREATE_TIME <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(String value) {
            addCriterion("CREATE_TIME <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLike(String value) {
            addCriterion("CREATE_TIME like", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotLike(String value) {
            addCriterion("CREATE_TIME not like", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<String> values) {
            addCriterion("CREATE_TIME in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<String> values) {
            addCriterion("CREATE_TIME not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(String value1, String value2) {
            addCriterion("CREATE_TIME between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(String value1, String value2) {
            addCriterion("CREATE_TIME not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andDelFlagIsNull() {
            addCriterion("DEL_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andDelFlagIsNotNull() {
            addCriterion("DEL_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andDelFlagEqualTo(Integer value) {
            addCriterion("DEL_FLAG =", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagNotEqualTo(Integer value) {
            addCriterion("DEL_FLAG <>", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagGreaterThan(Integer value) {
            addCriterion("DEL_FLAG >", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("DEL_FLAG >=", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagLessThan(Integer value) {
            addCriterion("DEL_FLAG <", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagLessThanOrEqualTo(Integer value) {
            addCriterion("DEL_FLAG <=", value, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagIn(List<Integer> values) {
            addCriterion("DEL_FLAG in", values, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagNotIn(List<Integer> values) {
            addCriterion("DEL_FLAG not in", values, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagBetween(Integer value1, Integer value2) {
            addCriterion("DEL_FLAG between", value1, value2, "delFlag");
            return (Criteria) this;
        }

        public Criteria andDelFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("DEL_FLAG not between", value1, value2, "delFlag");
            return (Criteria) this;
        }
        
        public Criteria andUnionIdEqualTo(Long value) {
            addCriterion("UNION_ID =", value, "unionId");
            return (Criteria) this;
        }
        
        public Criteria andRoleNameNotNull() {
            addCriterion("id in (select t.USER_ID from t_sys_user_role t)");
            return (Criteria) this;
        }
        
        public Criteria andUnionIdNotNull() {
            addCriterion("UNION_ID is not null and UNION_ID in (select u.id from gh_union_info u where u.union_status = 0)");
            return (Criteria) this;
        }
        
        public Criteria andUnionCodeLike(String value) {
            addCriterion("UNION_ID in (select ui.id from gh_union_info ui where ui.union_code like '"+value+"' and ui.union_status = 0)");
            return (Criteria) this;
        }
    }

    /**
     *  * t_sys_user
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * t_sys_user null
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}